﻿CREATE TABLE [dbo].[ExposureCache] (
    [Author]                    VARCHAR (100)     NULL,
    [BaseUri]                   VARCHAR (500)     NULL,
    [Content]                   VARCHAR (MAX)     NULL,
    [Copyright]                 VARCHAR (500)     NULL,
    [LastUpdatedTime]           DATETIME          NOT NULL,
    [Link]                      VARCHAR (500)     NULL,
    [PublishDate]               DATETIME          NOT NULL,
    [Summary]                   VARCHAR (MAX)     NULL,
    [Title]                     VARCHAR (500)     NULL,
    [Circle]                    VARCHAR (100)     NULL,
    [BoxUpper]                  VARCHAR (100)     NULL,
    [BoxLower]                  VARCHAR (100)     NULL,
    [Id]                        INT               IDENTITY (1, 1) NOT NULL,
    [EmergencyMessageContentId] INT               NOT NULL,
    [GeoRSS]                    XML               NULL,
    [Envelope]                  VARCHAR (100)     NULL,
    [Polygon]                   XML               NULL,
    [GeoRSSWhere]               [sys].[geography] NULL,
	[ExpirationTime]            DATETIME          NULL, 
    [ContentHash] INT NULL, 
    [DEId] VARCHAR(500) NULL, 
    [DESender] VARCHAR(500) NULL
);



